package com.lw.ssm.mapper;

import com.lw.ssm.pojo.Score;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author Administrator
 * @version 1.0
 * @description:
 * @date 2022/3/12 10:54
 */
public interface ScoreMapper {
    @Select("select * from score where stu_id=#{stuId}")
    List<Score> findById(Long stuId);

    @Select("select * from score")
    List<Score> findAll();

    void addScore(Score score);

    void updateScoreById(Score score);

    @Delete("delete from score where stu_id=#{id}")
    void deleteScore(Long id);
}

